IF NOT EXISTS(SELECT * FROM dbo.sysobjects where id = object_id(N'dbo.WebSite') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
	CREATE TABLE dbo.WebSite
		(
			WebSiteID int IDENTITY(1,1) NOT NULL,
			SiteCollectionID uniqueidentifier NOT NULL,
			SiteCollectionName nvarchar(100) NULL,
			WebID uniqueidentifier NOT NULL,
			WebName nvarchar(100) NULL,
			FullUrl nvarchar(1000) NULL
		)
	ON [PRIMARY]
	
	ALTER TABLE dbo.WebSite WITH NOCHECK ADD 
		CONSTRAINT [PK_WebSite] PRIMARY KEY CLUSTERED 
			(
			WebSiteID
			)
	ON [PRIMARY]
END
GO